Verified Document

Team D. Agreed To Focus Research Paper

Foreign key fields (i.e. The key that represents the value of a primary key in a related table) may exist in the case of CLEBSI speciment: date of diagnosis, date and time of specimen (where latter may replicate). Under 'Patient', CLEBSI line is a foreign key, too.

V. Atomic-level data

Atomic data would be the most reducible element of information (without elaboration). So for instance for hand hygiene it would be Chlorhexidine Skin Antisepsis Antimicrobial Dressing Placement

VI. Schemas of the database will be:

Patient with the attributes of name, age, medical record number (MRN), diagnosis, central line; Central line with the attributes of medical record number, date of insertion, insertion site, date of removal, line days, inserting provider, the components Central Line Bundle compliance, antimicrobial dressing placement; and CLABSI infections with attributes of MRN, date of diagnosis, date and time of specimen, organism detected. Central Line Bundle compliance will be measured by the evidence-based standards determined by the Institute for Healthcare Improvement (IHI, n.d).

In short, the data will be organized in the following way:

Patient, Central Line, CLABSI Infection will be the field names. The primary key of the Patient table will be the MRN, of the Central Line Table - the Insertion site, and of CLABSI infection -MRN.

Their attributes will be the 'master keys' with the relevant information (i.e., the details) being the 'order' keys. These 'order' keys...

For presentation of these order keys see above under field types.
The entire assignment was somewhat complex, but once I had an idea of the requirements of CLABSI, and reformulated some of the information I was able to get past the roadblocks. One challenge, for instance, was determining the primary keys for Central Line and CLABSI since the central line by the former can by definition exist of more than one, and even more than one on the same day. I, therefore, transferred primary key to Insertion site. By CLABSI, I left MRN as primary key since we are focusing on the Primary Blood Stream Infection (BSI) and it is this that health-care institutions use to record presence of CLABSI (CDC, 2010)

Reference

CDC (2010) Central Line-Associated Bloodstream Infection (CLABSI) Event. Retrieved April 1, 2011 from www.cdc.gov/nhsn/PDFs/pscManual/4PSC_CLABScurrent.pdf

Databasics: A Database Dictionary. Retrieved April 1, 2011 from: http://www.geekgirls.com/database_dictionary.htm

Institute for Healthcare Improvement. (n.d.). Implement the central line bundle. Retrieved March 21, 2011, from http://www.ihi.org/IHI/Topics/CriticalCare/IntensiveCare/Changes/ImplementtheCentralLineBundle.htm

Moodle. Database Fields. Retrieved April 1, 2011 from http://docs.moodle.org/en/Database_fields#Field_name_and_description

Walkthrough: Creating a Master / Detail. Retrieved April 1, 2011 from http://msdn.microsoft.com/en-us/library/y8c0cxey.aspx

Sources used in this document:
Reference

CDC (2010) Central Line-Associated Bloodstream Infection (CLABSI) Event. Retrieved April 1, 2011 from www.cdc.gov/nhsn/PDFs/pscManual/4PSC_CLABScurrent.pdf

Databasics: A Database Dictionary. Retrieved April 1, 2011 from: http://www.geekgirls.com/database_dictionary.htm

Institute for Healthcare Improvement. (n.d.). Implement the central line bundle. Retrieved March 21, 2011, from http://www.ihi.org/IHI/Topics/CriticalCare/IntensiveCare/Changes/ImplementtheCentralLineBundle.htm

Moodle. Database Fields. Retrieved April 1, 2011 from http://docs.moodle.org/en/Database_fields#Field_name_and_description
Walkthrough: Creating a Master / Detail. Retrieved April 1, 2011 from http://msdn.microsoft.com/en-us/library/y8c0cxey.aspx
Cite this Document:
Copy Bibliography Citation

Related Documents

Team and Group Dynamics
Words: 1452 Length: 4 Document Type: Term Paper

Strengthening Others for Team Excellence For a team to be successful in their activities, they need a strong leader who will bring the team together by ensuring the team members trust each other and look forward to achieving the goal of the team. According to Northouse (2012), the team leader is important and should exhibit traits such as intelligence, confidence, integrity, and determination. Kouzes and Posner (2012) also suggest similar qualities

Leadership and Team Management
Words: 2863 Length: 10 Document Type: Essay

1. Part A: Describe the factors that influence you to choose a Leadership Style. (minimum of 6 paragraphs) The factors that influenced my leadership style came from observing leaders behaviors and how they affected me and other employees positively and negatively. For example, I have observed employee reactions and behaviors based on the leader’s style. I got engaged and enjoyed working with leaders, especially when they based the relationship with employees on

Hostage/Crisis Negotiation Team: Analysis of the Specific Functions...
Words: 3469 Length: 12 Document Type: Research Paper

Negotiation Crisis Team The process of hostage and crisis negotiation is an event that involves a team, it is not something that can be performed by an individual and cannot be considered as a secondary activity. Such negotiations are meant to help in the management and/or resolution of very risky situations, and in most cases the situations are very tricky to deal with. The manner in which these situations present themselves

Soviet-Afgan War Conflict Analysis Focus
Words: 5116 Length: 18 Document Type: Thesis

(Harvey, 2003) the suspicion of the United States of the "Soviet Expansionist tendencies" had increased by the 1970s and Harvey states as well that "The pervasive mentality of Washington officials during these years was dominated by the communist domino theory which led many Washington politicians to believe that the Soviet Union sought to take over the entire world." (2003) the United States had always received a safeguard provided by

Subcontracting Analysis Cont'd What Factors
Words: 7083 Length: 26 Document Type: Term Paper

For example, in their study, "Nawkaw, Inc.: Changing the Color of Masonry," Amason and Ciavarella (2001) report that, "Commercial jobs usually were won through competitive bidding by general contractors, who then hired subcontractors. Sometimes general contractors did not seek bids, instead choosing subcontractors on the basis of their past performance" (p. 77). Other factors involved that will likely influence which subcontractor will be selected relate to the organizational structure of

Aligning Human Resources for Organizational Success
Words: 3510 Length: 11 Document Type: Essay

Strategy for Maximizing Human Resources In the current business environment, companies have increasingly used performance appraisal methods to align their human resources activities and policies in ensuring promoting the realization of organizational goals and objectives. Practice and research have shifted from their narrow focus on psychometric evaluation of issues to the developmental performance appraisal. Performance appraisal promotes the performance of a business by enriching the employees with experiences, attitudes, and skills.

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now